Create Databases 8

Steps to Create a Database in SQL Server Management Studio

Step 1: Open SQL Server

To start, open Microsoft SQL Server Management Studio.

To avoid any permission issues, you may want to run SQL Server Management Studio as an administrator:

Step 2: Connect to your Server

Step 3 : Create your Database

Under the Object Explorer, you’ll see the Databases Folder. Right click on that folder and then select New Database… from the drop-down list

Reminder: If you don’t see the newly created database then Right-click on the Databases folder under the Object Explorer, and then select Refresh from the drop-down list:

We will create 3 databases for this project:

·       GunViolenceStaging
·       GunViolence_ODS
·       GunViolence_DW

Here are the links to download SQL Server Management Studio(SSMS) and SQL Server Data Tools:

SSMS https://docs.microsoft.com/en-us/sql/ssms/release-notes-ssms?view=sql-server-ver15#previous-ssms-releases

SSDT https://docs.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt?view=sql-server-ver15